﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;
using System.Web.Routing;
using System.Data.SqlClient;
using System.Configuration;

namespace TaggerApp
{
    public class Global : System.Web.HttpApplication
    {
        public string appName;
        protected void Application_Start(object sender, EventArgs e)
        {
            RouteConfig.RegisterRoutes(RouteTable.Routes);
        }

        protected void Session_Start(object sender, EventArgs e)
        {

        }

        protected void Application_BeginRequest(object sender, EventArgs e)
        {

        }

        protected void Application_AuthenticateRequest(object sender, EventArgs e)
        {

        }

        protected void Application_Error(object sender, EventArgs e)
        {

        }

        protected void Session_End(object sender, EventArgs e)
        {

        }

        protected void Application_End(object sender, EventArgs e)
        {

        }
        public void GetTitleFromDB()
        {
            using (SqlConnection sqlCon = new SqlConnection())
            {
                sqlCon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText =
                        @"SELECT TOP 1 applicationName FROM tblAdminConfig ORDER BY applicationName DESC";
                    cmd.Connection = sqlCon;
                    sqlCon.Open();

                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            appName = (String)reader[0];
                        }
                        else
                        {
                        }
                    }
                }
            }
        } 

    }
}